Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$AQ

`V$AQ` displays statistics for the queues in the database.

Column | Datatype | Description
--- | --- | ---
`QID` | `NUMBER` | Unique queue identifier
`WAITING` | `NUMBER` | Number of messages in the queue in the state '`WAITING`'
`READY` | `NUMBER` | Number of messages in the queue in the state '`READY`'
`EXPIRED` | `NUMBER` | Number of messages in the queue the state '`EXPIRED`'
`TOTAL_WAIT` | `NUMBER` | Total wait time of all '`READY`' messages in the queue
`AVERAGE_WAIT` | `NUMBER` | Average wait time of '`READY`' messages in the queue